== Number of files ==
60

== Filename pattern==
{application}_{semester id}_{data type}.txt
* application
	- sqlknot - http://adapt2.sis.pitt.edu:8081/wiki/SQLKnoT
	- webex_sql - http://adapt2.sis.pitt.edu:8081/wiki/WebEx (SQL examples)
* semester id - 6 semester ids: 404,535,592,759,760,850
* data type - 5 data types: a, ac, c, d, u, a (details below)

2 applications x 6 semesters x 5 data types = 60 files

==Data types==
All data in files is tab separated values, below is the specification of the columns for all the types

* a - activities (problems or examples)
	activity id
	activity label
	URI of the activity
	number of subordinates - only for webex_sql application
* c - concepts (knowledge items)
	concept id
	concept label
* ac - activity-concept index
	activity id
	activity label
	concept id
	concept label
	concept-activity link weight
	concept-activity link direction (0-prerequisite, 1-outcome)
* u - users
	user id
	user login hash
	number of user actions (disregard this one)
* d - the log itself
	user id
	activity id
	result (0-problem error, 1-problem correct, -1-example click)
	date (yyyy-mm-dd HH:MM:SS.FFF)
	subordinate id - only for webex_sql application - in addition to activity id (here example id), the id of the line

